Beyond the Report Card: Investigating the Factors that Define Educational Achievement

Author

Thu Dang, Nathaniel Reimer, Jeremy Hubinger

Published

May 8, 2023

Modified

April 25, 2023

Comparing Performance Metrics

At The County Level

At The School Level

Funding and Achievement Correlation

                    Estimate Std. Error  t value     Pr(>|t|)
(Intercept)        11365.441   184.1742 61.71027 0.000000e+00
as.numeric(perfrl)  3170.302   283.2011 11.19452 1.334886e-28

Something Something GCS Map

Choosing Variables

cbind(data\(ela_data_currstatus_ALL, data\)gcs_mn_avg_ol, data\(science_data_Earth.and.Space.Sciences.Domain.Percent.Above.Standard_99, data\)science_data_Life.Sciences.Domain.Percent.Above.Standard_99, data\(science_data_Physical.Sciences.Domain.Percent.Above.Standard_99, data\)growthscore_ela, data$growthscore_math)

    variable      FundingType          DOCType            SOCType         
 Min.   :0.2255   Length:312         Length:312         Length:312        
 1st Qu.:0.4554   Class :character   Class :character   Class :character  
 Median :0.5890   Mode  :character   Mode  :character   Mode  :character  
 Mean   :0.5904                                                           
 3rd Qu.:0.7397                                                           
 Max.   :0.9055                                                           
  EdOpsCode          EdOpsName          GSoffered           GSserved        
 Length:312         Length:312         Length:312         Length:312        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  
                                                                            
                                                                            
                                                                            
   Virtual             Magnet          pp_stloc_raw        pp_fed_raw       
 Length:312         Length:312         Length:312         Length:312        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  
                                                                            
                                                                            
                                                                            
  pp_total_raw   pp_total_norm_NERDS  flag_nerds          flag_f33        
 Min.   : 8326   Length:312          Length:312         Length:312        
 1st Qu.:10794   Class :character    Class :character   Class :character  
 Median :12375   Mode  :character    Mode  :character   Mode  :character  
 Mean   :12740                                                            
 3rd Qu.:13956                                                            
 Max.   :40568                                                            
 schoolstloc_raw    schoolfed_raw      schooltot_raw       ncesenroll       
 Length:312         Length:312         Length:312         Length:312        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  
                                                                            
                                                                            
                                                                            
  enroll_raw        enrollmetric_raw    gradespan          gradecenter   
 Length:312         Length:312         Length:312         Min.   :4.000  
 Class :character   Class :character   Class :character   1st Qu.:4.000  
 Mode  :character   Mode  :character   Mode  :character   Median :4.250  
                                                          Mean   :4.901  
                                                          3rd Qu.:5.500  
                                                          Max.   :7.500  
      gap    gcs_mn_avg_ol    gcs_mn_avg_eb         mingrd          maxgrd     
 Min.   :0   Min.   :0.1161   Min.   :-0.2344   Min.   :3.000   Min.   :5.000  
 1st Qu.:0   1st Qu.:0.3192   1st Qu.: 2.9193   1st Qu.:3.000   1st Qu.:5.000  
 Median :0   Median :0.4308   Median : 4.6736   Median :3.000   Median :5.000  
 Mean   :0   Mean   :0.4332   Mean   : 4.7219   Mean   :3.679   Mean   :6.099  
 3rd Qu.:0   3rd Qu.:0.5197   3rd Qu.: 6.0270   3rd Qu.:3.000   3rd Qu.:8.000  
 Max.   :0   Max.   :1.0000   Max.   :13.2181   Max.   :7.000   Max.   :8.000  
    charter             magnet          urbanicity           locale         
 Min.   :0.000000   Min.   :0.000000   Length:312         Length:312        
 1st Qu.:0.000000   1st Qu.:0.000000   Class :character   Class :character  
 Median :0.000000   Median :0.000000   Mode  :character   Mode  :character  
 Mean   :0.003205   Mean   :0.003205                                        
 3rd Qu.:0.000000   3rd Qu.:0.000000                                        
 Max.   :1.000000   Max.   :1.000000                                        
    sch_sped    totenrl            perwht             pernam        
 Min.   :0   Min.   :  20.11   Min.   :0.002103   Min.   :0.000000  
 1st Qu.:0   1st Qu.: 402.39   1st Qu.:0.084217   1st Qu.:0.001913  
 Median :0   Median : 548.11   Median :0.247253   Median :0.003510  
 Mean   :0   Mean   : 576.71   Mean   :0.336009   Mean   :0.008123  
 3rd Qu.:0   3rd Qu.: 702.52   3rd Qu.:0.572283   3rd Qu.:0.006205  
 Max.   :0   Max.   :1430.59   Max.   :0.906008   Max.   :0.418245  
     perasn            perhsp            perblk            perfl        
 Min.   :0.00000   Min.   :0.02089   Min.   :0.00000   Min.   :0.01007  
 1st Qu.:0.06256   1st Qu.:0.12688   1st Qu.:0.01929   1st Qu.:0.08625  
 Median :0.13344   Median :0.23441   Median :0.04642   Median :0.37772  
 Mean   :0.22270   Mean   :0.32002   Mean   :0.11315   Mean   :0.38388  
 3rd Qu.:0.32361   3rd Qu.:0.48005   3rd Qu.:0.15800   3rd Qu.:0.64783  
 Max.   :0.92754   Max.   :0.97823   Max.   :0.80324   Max.   :0.88119  
     perrl             perfrl            perecd          gifted_tot     
 Min.   :0.00456   Min.   :0.01804   Min.   :0.01265   Min.   :0.00000  
 1st Qu.:0.02601   1st Qu.:0.11436   1st Qu.:0.15209   1st Qu.:0.01483  
 Median :0.06020   Median :0.45795   Median :0.48248   Median :0.03856  
 Mean   :0.06088   Mean   :0.44469   Mean   :0.45849   Mean   :0.05654  
 3rd Qu.:0.09142   3rd Qu.:0.75569   3rd Qu.:0.75036   3rd Qu.:0.07686  
 Max.   :0.17668   Max.   :0.94266   Max.   :0.96186   Max.   :0.48044  
   disab_tot       disab_tot_idea         lep           gifted_flag      
 Min.   :0.00000   Min.   :0.00000   Min.   :0.00000   Min.   :0.000000  
 1st Qu.:0.08589   1st Qu.:0.07463   1st Qu.:0.07324   1st Qu.:0.000000  
 Median :0.11148   Median :0.09778   Median :0.16451   Median :0.000000  
 Mean   :0.11524   Mean   :0.10200   Mean   :0.21552   Mean   :0.003205  
 3rd Qu.:0.14211   3rd Qu.:0.12662   3rd Qu.:0.32435   3rd Qu.:0.000000  
 Max.   :0.25858   Max.   :0.24668   Max.   :0.83224   Max.   :1.000000  
    lep_flag         sped_flag spedidea_flag    avgrdall      
 Min.   :0.00000   Min.   :0   Min.   :0     Min.   :  1.843  
 1st Qu.:0.00000   1st Qu.:0   1st Qu.:0     1st Qu.: 64.834  
 Median :0.00000   Median :0   Median :0     Median : 91.060  
 Mean   :0.08333   Mean   :0   Mean   :0     Mean   :124.041  
 3rd Qu.:0.00000   3rd Qu.:0   3rd Qu.:0     3rd Qu.:127.022  
 Max.   :1.00000   Max.   :0   Max.   :0     Max.   :560.302  
   LowGrade          HighGrade        
 Length:312         Length:312        
 Class :character   Class :character  
 Mode  :character   Mode  :character